|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | SQL Search | |
| rosenowsr 6/14/2020 8:38:44 AM | Jeff is it possible to make a udm in SQL(inside the jcapper program with out using excel) and not using factors in the factor list? Could you give an example?
| |
| jeff 6/17/2020 12:09:20 PM | If by "the factors list" you mean The Key Factors Report in the Data Window, then the answer is yes. If by "the factors list" you mean the column names in the Table Schema then the answer is no. Link to the StarterHistory Table Schema - here: http://www.jcapper.com/helpdocs/starterhistorytableschema.html The rules are: • Every column name that you reference in a sql udm or a sql expression that you execute in the Data Window must be an actual column name that exists in the StarterHistory table. • Every column name in the Table Schema can be used in in a sql udm. Example: PRating is a factor that doesn't appear on the Key Factors Report. PaceTop is also a factor that doesn't appear on the Key Factors Report. But rankPRating, gapPRating, PRating, and PaceTop are each valid column names in the StarterHistory table (per the Table Schema.) I could use PRating and PaceTop in a sql udm like this: SELECT * FROM STARTERHISTORY WHERE RANKPRATING = 1 AND PACETOP = 0 -jp .
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |